﻿CREATE TABLE [dbo].[Customer]
(
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[RowId] [uniqueidentifier] ROWGUIDCOL DEFAULT (NEWID()) NOT NULL,
	[IsDeleted] [bit] NOT NULL,
	[CreatedDate] [datetime] NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
	[ModifiedByUserId] [int] NULL,
	[Version] [timestamp] NOT NULL,
	[ProjectId] [int] NOT NULL,
	[Name] [nvarchar](64) NOT NULL,
	[Gender] [nvarchar](1) NULL,
	[Age] [smallint] NULL,
	[IdentityNumber] [varchar](32) NULL,
	[QQ] [varchar](32) NULL,
	[Phone] [varchar](32) NULL,
	[Mobile] [varchar](32) NOT NULL,
	[Email] [varchar](256) NULL,
	[PostalCode] [varchar](8) NULL,
	[Address] [nvarchar](128) NULL,
	[DistrictId] [int] NULL,
	[InformationSourceId] [int] NULL,
	[SalesEmployeeId] [int] NOT NULL,
	[Comment] [nvarchar](512) NULL,
)